﻿USE CORINA_DATA
GO

CREATE TABLE t_third_party_measure (
    Id INT PRIMARY KEY IDENTITY,
    UserId INT DEFAULT(0),
    Applicant VARCHAR(50),
    ApplyUnit VARCHAR(100),
    ApplyDate DATETIME DEFAULT(GETDATE()),
    Specimen VARCHAR(100),
    SpecimenKindId INT DEFAULT(0),
    MeasureObject VARCHAR(50),
    Density FLOAT DEFAULT(0),
    DensityUnit VARCHAR(50),
    Humidity FLOAT DEFAULT(0),
    Temperature FLOAT DEFAULT(0),
    MeasureTime DATETIME DEFAULT(GETDATE()),
    MeasureDevice VARCHAR(100),
    Tester VARCHAR(50),
    SubmitTime DATETIME DEFAULT(GETDATE())
)